from django.db import models

class ItemList(models.Model):
	name = models.CharField(max_length=30)
	ParentName = models.CharField(max_length=30)
	level = models.IntegerField()
	
class ItemInfo(models.Model):
	ItemID = models.IntegerField(db_index=True)
	ItemName = models.CharField(max_length=50)
	price = models.IntegerField()
	num = models.IntegerField()
	PriceAll = models.IntegerField()
	satisfaction = models.IntegerField()
	brand = models.CharField(max_length=30,null=True)
	market = models.CharField(max_length=30,null=True)
	OtherInfo = models.CharField(max_length=500,null=True)
	
class rgf(models.Model):
	ItemID = models.IntegerField(db_index=True)
	ItemName = models.CharField(max_length=50)
	unit = models.CharField(max_length=10)
	price2011 = models.IntegerField()
	price2000 = models.IntegerField()
	info = models.CharField(max_length=50)
	realNum = models.IntegerField()
	